CREATE PROC SP_GET_SUATCHIEU_TU_MAPHIM_NGAYCHIEU
@MAPHIM INT, @THOIGIANBATDAU DATETIME
AS
BEGIN TRAN
SET TRAN ISOLATION LEVEL SERIALIZABLE
	SELECT SC.MaSuatChieu,SC.MaPhim, SC.MaPhongChieu,SC.ThoiGianBatDau, SC.ThoiGianKetThuc, SC.SoLuongVe
	FROM SUATCHIEU SC
	WHERE SC.MaPhim = @MAPHIM
	AND DATEDIFF(DD, SC.ThoiGianBatDau, @THOIGIANBATDAU) = 0
commit
GO